SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 430974 LIMIT 1 [ RunTime:0.000502s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 430974 [ RunTime:0.001536s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (635343,557182,499225,750438,741733,1009809,433898,871041,278523,836775,203869,119869,841717,871078,37658,192805,461542,366735,911954,299914,918776,279504,447894,174806,993237,719602,501807,267384,652451,738760,431278,606548,1003997,342306,325495,1013322,384252,222865,1036190,171933,454157,404183,244469,786007,795628,199747,830350,693264,475179,1017076,455829,78901,861566,152277,789985,41507,335053,120484,131645,1003633) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 430974 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 430974 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000658s ]