SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516213 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516213 [ RunTime:0.003155s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (356851,417349,675571,188147,147251,963821,947468,793790,899938,99574,591123,236675,408916,673720,237478,335550,577,614299,520870,901961,165602,52214,660516,839802,761594,106797,1028562,882590,41379,124667,523427,580866,436673,441944,971341,798283,1009225,673627,965370,368482,1013487,866188,722657,1048392,802196,408894,770905,819019,500960,442142,62154,563968,293656,325454,213655,1047283,981720,433184,58763,987775) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000669s ]