SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018528 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018528 [ RunTime:0.001624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (620986,465395,254404,214118,54888,480637,595648,603052,104235,381160,103452,532011,56139,220642,100349,805582,508419,162438,580779,675053,253285,387469,993218,998983,481046,760366,1035114,436844,517491,205731,118208,706199,194250,352583,299495,958477,354649,806248,571448,205242,289871,867778,83074,612738,843370,587314,122014,350220,466058,876122,272370,1039515,439258,530086,830743,980682,20883,746633,224653,918475) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.020489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001203s ]