SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412924 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412924 [ RunTime:0.002088s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010036,131600,681976,416156,121395,931642,82226,63646,536036,838755,810450,136482,502969,214291,209913,551535,58581,35374,964010,545134,793255,7430,109775,171645,546078,648397,667778,52702,167884,814903,503300,247210,585412,516556,445169,369538,674638,819978,777301,43483,999672,587675,690172,886937,271731,288979,544059,466452,349573,498557,532918,50883,100462,531775,964596,11868,70479,61474,326805,362169) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001679s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412924 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412924 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]