SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542427 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542427 [ RunTime:0.001697s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (279238,268901,1039796,16641,829086,259353,219473,106781,306146,744409,14377,895063,159534,323438,1020021,245791,689508,907493,265192,425160,144306,95289,762070,1004477,120351,218906,625045,780052,714832,590881,122939,1035815,605997,138984,436609,665973,726021,383473,205663,238541,1037037,38032,395327,127271,803811,609280,608998,415736,636101,437777,530594,579103,569481,832249,234757,212915,273529,958433,324708,1025765) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542427 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542427 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]