SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 496912 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 496912 [ RunTime:0.001855s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (765645,962700,158366,376829,990148,254935,447545,771110,726057,420885,826622,633038,899736,902639,441380,926789,41916,289638,237582,451593,145348,749494,198142,616971,122876,659003,627319,149984,296771,592497,339737,219444,664855,307482,499266,209817,642480,347049,14869,968959,735847,663936,187046,748824,477538,189374,735009,861973,424175,964920,366667,1023506,1036087,296840,93358,1048168,751416,419235,134504,956716) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 496912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 496912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]