SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544575 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544575 [ RunTime:0.001668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1031448,523066,249200,17105,805969,516563,837925,187181,328581,1007709,193441,188250,284722,717932,777298,767795,611557,989302,418805,95916,1016226,760354,43638,12460,679446,655375,417984,136333,355584,649179,862032,950212,362940,157662,465293,872202,713845,855176,648530,554817,307324,603763,177666,218509,428749,238422,504531,663595,70880,636052,465004,59386,364802,108304,736204,609311,940309,713884,658807,938847) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544575 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544575 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]