SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020238 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020238 [ RunTime:0.002128s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (526830,808313,500231,968153,349156,213524,445084,387227,954725,1009700,66396,810330,458209,187288,93011,356551,441930,426,558385,1007891,177425,695545,889229,64244,811332,135929,969531,997028,801525,363481,457483,699791,201851,831900,1032771,572054,715453,752943,230569,805704,4118,949354,650629,415340,68689,861335,116657,451744,380505,762130,765698,429484,591756,369209,923901,400942,118125,691427,234751,675289) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007903s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020238 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020238 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000360s ]