SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026475 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026475 [ RunTime:0.001463s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (37710,601956,349787,162478,457322,649827,228205,757575,293509,497275,831149,756911,110784,364898,604830,63904,983954,738199,161918,597320,268014,316382,518953,250757,6441,980010,562545,158817,346512,282870,205965,40355,1006739,692875,384956,893732,193411,547580,214702,140254,836222,861727,438409,172513,784147,364466,291141,745168,778828,52271,344385,825529,652469,1039602,43925,375752,820200,468538,297080,932151) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026475 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026475 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]