SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002617s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014907 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014907 [ RunTime:0.002766s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (493200,523977,412944,33836,984666,18730,164624,298314,636973,1039848,1039486,978679,26131,575913,724588,954307,948609,487997,142396,557009,467048,706076,110084,5350,509077,296510,354903,1035162,292525,863538,1045004,640770,205107,978529,127291,618444,199889,863406,77639,876809,494355,1035419,96148,924679,60731,903595,182638,580860,772590,339687,1012157,79447,842061,720529,183511,376521,484022,988247,3737,616067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001784s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014907 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000635s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014907 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]