SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 145573 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 145573 [ RunTime:0.001456s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (310779,286203,759439,709752,586600,1042898,749625,110545,277767,1034729,638128,630207,191587,364433,946507,494811,469027,168594,576531,954388,251169,140843,1026400,25845,270328,1043870,544328,156236,655231,1025719,349754,128077,820514,313706,815766,924270,1033530,911642,380900,548253,86357,272036,1004080,315230,682849,764242,454067,322946,1048470,831673,732514,698884,282220,574556,376629,736025,448769,256727,863149,888663) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 145573 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 145573 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]