SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003311s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543938 LIMIT 1 [ RunTime:0.004427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543938 [ RunTime:0.008822s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405320,444401,605316,206637,633973,886264,98399,640504,262788,19405,300015,701006,333193,341294,97324,99370,188713,597644,679661,693428,37615,802499,551465,186261,577197,994776,932677,478952,163938,171033,849334,902770,313467,682803,45516,546818,978132,241732,615390,208361,364622,632763,677436,72854,990579,1018912,1001444,277510,531706,949345,307152,218006,31878,433867,638112,245677,1017688,740140,353729,101642) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001781s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543938 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543938 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]