SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 162008 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 162008 [ RunTime:0.001833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (732074,998289,451595,664833,705821,232520,821704,101975,404626,388818,802295,326,426265,1048303,131904,176458,608980,828652,13290,56756,793220,475774,193836,584135,918122,170966,44444,567672,197436,874251,549952,717031,904065,471340,623155,659541,949629,539279,375586,941037,934902,816689,488459,810983,250853,817661,895653,217591,46318,1027765,429310,1014725,732567,226665,327513,838192,533254,907972,307933,133990) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 162008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 162008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]