SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316743 LIMIT 1 [ RunTime:0.001768s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316743 [ RunTime:0.005250s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (840954,280975,610460,906325,748357,45604,197344,530870,942344,128606,967741,420178,159698,985687,152279,857897,118579,200111,983675,706343,884073,275717,950176,229098,449443,320186,175679,241044,984537,724469,1046404,764934,474319,223651,480865,905876,498665,551973,239455,851479,387703,607915,570002,382247,114122,179686,262158,175649,976395,1026842,861635,496937,541887,473993,1023542,9125,53793,386756,458223,668068) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000589s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000967s ]