SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410419 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410419 [ RunTime:0.006533s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (748251,88090,1020912,988451,327886,925449,776792,244632,896748,22837,1003873,701138,484648,990816,672120,811668,100662,1007026,935461,858266,352459,497299,949340,800939,11720,667822,601896,171979,270575,657503,480875,358132,443861,413417,88596,1037240,139344,382204,523578,18037,326200,419266,387336,645824,322535,195604,842210,265720,630312,868284,731702,659003,747025,853359,942160,85590,89436,943277,473891,619659) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001617s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410419 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002550s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410419 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004869s ]