SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1007214 LIMIT 1 [ RunTime:0.001077s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1007214 [ RunTime:0.001971s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (784957,497801,283369,890480,507876,739075,970665,673988,614933,122525,566669,797906,204809,651573,988313,447760,293217,475841,651474,106354,541502,695260,580563,950793,198883,633375,503775,1028855,392218,813046,642621,590901,846893,891167,683927,403560,627585,706624,1014366,747200,260484,1016688,380568,991393,669750,996197,899309,345362,496161,159279,776362,799242,976465,865169,953869,178553,551237,658887,898833,104579) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1007214 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1007214 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]