SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 64180 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 64180 [ RunTime:0.001624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (159351,211486,285821,853845,949659,67588,843734,229578,710415,795105,136210,466305,932677,5899,804971,224916,551405,16873,643748,291746,731415,240913,401893,658422,233214,648695,269281,874433,550739,660227,432993,389929,162559,1034232,675235,347862,238328,701317,684567,158097,385250,982041,872031,251517,811670,638802,392570,117403,24807,348074,473666,689405,141234,83232,107129,402290,724030,5178,395167,571296) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001733s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 64180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 64180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]