SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481980 LIMIT 1 [ RunTime:0.003423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481980 [ RunTime:0.002486s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (621063,795836,439312,556959,139784,860351,536711,722401,741232,825879,52606,630516,332677,737434,216072,309720,147524,56493,192577,695778,363705,884514,53909,608730,1029548,946066,611715,30664,927969,999006,162358,888771,479039,897572,461802,382150,882704,202843,224444,71283,798449,112050,370065,487171,426483,676892,569716,970221,601981,298662,415086,627062,465102,796287,1001919,752671,515779,281072,739698,420626) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]