SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580520 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580520 [ RunTime:0.001557s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499159,507745,95506,623875,136842,488879,342556,536631,769004,901287,605117,39118,803906,399484,692847,48234,92974,988777,133404,808737,163619,179227,661757,466089,619900,539423,887061,118379,401131,646567,518269,938540,48931,919591,230947,437838,726612,117988,879798,976776,806772,511296,314163,226450,515001,890982,232404,346366,1023039,995343,289846,750373,24566,13043,701426,194615,480448,903447,597393,749123) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580520 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580520 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]