SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 441575 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 441575 [ RunTime:0.002535s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (772272,104230,709069,1002507,550567,289742,776865,983275,941351,1013131,1008530,715764,427230,362192,1040463,433714,189992,616226,603415,558464,119927,602049,104617,201364,128689,146777,730984,283067,813891,695490,63226,383133,797995,642061,267673,760964,409510,334856,994605,24421,424273,219804,141708,797468,579304,987295,715693,393022,308662,15811,1017908,331894,776429,366182,707374,983856,1047699,185171,63054,592962) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 441575 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000624s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 441575 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]