SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544226 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544226 [ RunTime:0.001646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (494019,834899,108545,1024685,913018,196553,410263,719729,644581,550934,691693,152788,303149,153339,807549,222360,674517,538144,1006210,700399,606875,894092,987845,801971,955801,33328,714683,668315,836649,351049,513095,567492,685967,980,238242,704291,800158,766320,877623,349311,724427,674174,4318,160660,497641,775941,871154,436619,395934,337094,683420,160908,787324,27962,190587,736282,739413,414143,431709,589082) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000935s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544226 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544226 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]