SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436240 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436240 [ RunTime:0.001542s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (974177,383002,103629,360833,771738,662668,112160,968820,333892,89286,201269,626740,190903,75771,121928,136755,825319,889255,152839,984377,373684,60940,41939,470474,6386,874915,593379,887871,424068,190314,137101,1001112,478332,479129,680824,1003371,492671,243531,793548,201739,228632,308035,636527,734433,1026730,478226,965624,29287,395313,345453,831784,1007591,634621,545705,233574,867209,564300,392205,470875,70399) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436240 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436240 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000781s ]