SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195060 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195060 [ RunTime:0.002127s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (521021,646581,58518,133382,632364,730643,402599,248263,162501,522004,233304,849909,567697,289202,625815,422768,634137,126975,417152,870778,465903,495287,519059,94625,25882,848198,424387,45718,300237,696148,383305,588089,552100,553513,748013,77387,711873,148763,906733,43081,68559,148338,8211,253504,167050,856466,552495,327814,634181,316657,313162,394579,959807,537871,147765,271324,747564,443485,51357,436842) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195060 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195060 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]