SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545244 LIMIT 1 [ RunTime:0.000446s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545244 [ RunTime:0.005133s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (198972,86415,836314,798591,1027212,40878,153966,768884,284216,107099,914092,172333,272981,162981,24860,813769,894816,650922,226730,857884,373662,651479,474151,835453,850918,755955,269811,558083,308797,106464,606693,26512,537555,835021,490095,321819,909636,419267,681367,1017280,192719,40532,749282,548596,1014862,571304,778320,928217,484080,293291,337231,638733,992642,134536,636603,19605,701544,1043599,1045964,474179) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545244 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545244 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]