SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400222 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400222 [ RunTime:0.001735s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503589,1025657,640505,271665,743170,73840,693134,316550,507834,931222,772382,513048,252109,169202,584585,363499,7988,639876,427174,113106,741844,574691,544459,268051,923797,507265,284736,170661,225877,941228,53198,915506,557340,1021690,868813,176371,728844,788551,5168,446619,1007735,651875,418499,960032,418779,781812,567618,893065,167183,1031038,76746,66748,496765,288985,415772,312169,15812,957801,182468,658639) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400222 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400222 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]