SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413644 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413644 [ RunTime:0.005270s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101536,844290,1042902,59722,289266,25996,838301,625990,637845,396944,341863,454924,923452,784009,260497,203507,371783,460974,410569,383861,222837,124177,731089,382364,674979,869915,182142,927894,404616,714550,483254,84864,434414,173390,760743,619418,414984,16757,943344,831449,196346,669525,763871,347816,12018,354916,963327,127634,890933,73849,840859,601559,159912,396518,430288,518430,675833,898436,121848,660631) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001831s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413644 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413644 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]