SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048762 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048762 [ RunTime:0.001763s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (501523,665489,931235,580877,981222,700671,699572,399894,98592,841272,994441,882046,954182,969280,222786,302428,652654,231858,151628,136826,730108,310639,935334,1036239,561345,907088,1041791,274764,160652,404708,281538,779214,619814,686864,331381,61530,952552,389158,574006,134757,714204,1016145,561335,588894,412153,563423,141153,730483,244861,103711,204165,329190,256584,371083,955727,515907,71385,110022,163878,787953) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000943s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048762 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048762 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000420s ]