SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 992891 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 992891 [ RunTime:0.002687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (252404,31988,920578,784183,242815,885881,537379,479832,913441,254449,663187,533802,331389,286560,740839,561238,448510,688269,1741,352713,989530,703370,161231,1041382,571963,255853,272444,177081,609824,150724,171798,485557,971576,576125,690138,147095,209410,1044249,192952,187392,948606,697666,594767,30671,154561,162438,457174,923827,150740,458382,945249,735454,943557,897510,210002,428078,165040,939398,835769,861642) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 992891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 992891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]