SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 443470 LIMIT 1 [ RunTime:0.002769s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 443470 [ RunTime:0.005596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576283,241983,858235,1034728,388094,680799,988823,385520,668598,1034407,418624,256405,712095,154841,762088,386138,326865,411614,540429,882126,896670,152302,659270,1038038,775528,255967,931852,863117,31162,966599,499562,874060,142753,365659,526980,355259,372738,881515,222711,801782,556262,657249,469292,515844,200238,969604,106038,263394,151068,303858,408482,805260,702186,685037,1024265,117196,156368,985287,994390,534291) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 443470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000503s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 443470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001914s ]