SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423480 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423480 [ RunTime:0.001737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (893400,632153,830963,829288,412444,372354,998586,1010018,72416,619447,136729,932,625986,885080,381686,20599,820275,518395,691903,920032,233935,390750,409757,882344,779027,431698,24841,664400,71234,976799,826809,237212,653952,731096,812554,615062,712725,434734,621535,613889,574971,655548,85739,573732,118640,452850,812743,295265,425288,930891,435628,206152,344910,92051,625527,75085,207440,842318,277965,392654) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]