SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403650 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403650 [ RunTime:0.001627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (570281,665641,202900,259819,117026,817900,1036039,483905,96393,336921,93432,837153,316860,315931,519908,1010495,1035915,945440,579090,106854,457029,194676,89328,99050,320153,15348,992398,480778,711421,750232,867215,794302,690065,326511,229806,909564,644915,986543,7638,336462,318595,448697,1044922,998277,337292,721912,875381,878267,307918,17378,306799,907622,77871,984799,211325,241170,982315,272992,57626,105609) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403650 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403650 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]