SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475808 LIMIT 1 [ RunTime:0.001535s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475808 [ RunTime:0.002787s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1009126,360818,359204,78662,561875,559082,1043686,629853,549373,118888,751208,794154,278400,151495,918510,19897,755448,71378,48547,42915,180400,1035133,630509,735590,896125,495134,196163,831841,231935,523611,675070,659708,553220,302945,706158,807640,787772,111169,1048561,564687,442327,882440,662556,445643,845910,387721,138642,546171,1021999,1032694,937924,80179,283046,574469,230755,422280,763373,390525,931267,905234) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475808 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475808 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003312s ]