SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002382s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410930 LIMIT 1 [ RunTime:0.000627s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410930 [ RunTime:0.006909s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (355897,751444,943943,583184,122937,898639,187614,536653,656843,423232,970873,127387,1012496,980383,215006,778068,666377,383028,866175,100507,807825,978368,797188,740733,435874,691985,567100,167291,327964,226946,1045349,748580,54950,629892,1048410,885032,878128,576389,1000926,648702,709396,721586,519320,244901,414442,1003147,773821,880119,456067,720423,1048324,78954,305618,379793,95360,393445,151366,47370,17827,220615) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410930 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410930 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002509s ]