SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001501s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532200 LIMIT 1 [ RunTime:0.001051s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532200 [ RunTime:0.002451s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (320591,1017868,121854,970261,925341,265638,341910,562907,793688,284611,972496,476569,469723,897216,979049,211357,313956,645933,199863,122938,533104,961155,530623,332005,291967,219443,315888,392134,614627,1046667,799011,906941,35733,886843,99658,535531,63171,142554,421382,107824,295477,931783,847028,4428,273348,445005,482729,94576,1017331,500143,988025,694669,248676,550533,891189,240856,1019860,583602,267301,72385) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001901s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532200 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532200 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001163s ]