SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001403s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023218 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023218 [ RunTime:0.002504s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (453929,324561,207941,1006197,756250,643833,763771,915731,666732,907856,672386,10038,500269,258943,405534,1009794,184760,49491,233728,896097,342730,511645,673410,56071,860998,633962,48407,703315,105085,773921,21237,679812,510085,358061,1012267,531539,34804,145126,922686,215364,28693,401512,989266,773378,822540,1011383,60376,116615,898551,311806,1000136,325397,549951,290513,611565,214709,940054,1011867,286281,103555) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000670s ]