SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001381s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485741 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485741 [ RunTime:0.001671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (143429,490973,508212,679589,558920,245394,829850,186863,352778,436299,981371,569500,586210,362390,212973,552501,640687,193937,1634,717283,331804,867757,160000,67811,290351,448453,625203,2950,266714,1028536,118681,134379,377606,744501,568605,692966,719752,858375,909442,238989,255219,424485,671819,264963,40681,490361,256191,486550,281416,558047,718886,49710,848369,637996,126344,404685,743238,749365,1028175,906698) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001767s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485741 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485741 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]