SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283790 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283790 [ RunTime:0.001812s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1021612,3558,60122,645182,292306,971842,1003682,862061,96245,473223,794828,995100,257399,1024147,868487,44102,970987,800880,6488,208797,327943,89762,501597,8853,628156,567278,505542,743024,348196,905607,220242,253590,1015821,928108,542704,657242,111640,220615,943943,397840,352104,650013,618597,569187,838582,622759,951419,125833,640083,702055,34958,973905,189688,84935,86790,416579,303000,414935,862762,336373) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283790 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283790 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]