SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501969 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501969 [ RunTime:0.003227s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (995705,565650,840017,1012403,101078,640207,682893,626820,344812,13990,514548,498571,767959,157549,22881,39908,954118,992579,251865,920596,613891,364787,193176,764353,881830,254992,946931,190698,214972,140497,540912,843064,207406,514227,367841,143673,125057,924582,996279,1012004,546152,222509,622416,928264,686729,495471,239634,541209,853049,943028,699217,700113,944629,170006,266113,435477,371184,849211,978775,54401) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501969 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000545s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501969 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]