SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410072 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410072 [ RunTime:0.002107s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (202925,682292,230419,56306,573698,824537,818972,73102,91534,711098,234469,45203,199050,189262,260805,170259,1018326,67570,42607,336360,68281,122869,256953,81550,246681,557201,421513,20613,538028,702789,288903,264815,155885,515985,827502,814704,552883,21393,452716,421630,577544,807055,93436,878317,482634,528038,710176,13829,207467,1009643,383852,825060,902046,684435,143563,561809,416338,152728,559210,860849) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410072 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410072 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]