SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048457 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048457 [ RunTime:0.002596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (190664,1036086,534675,1016300,218580,296565,282226,63215,565525,1045469,977793,579576,110787,905267,436621,877150,26685,669950,233306,944292,175574,35721,275190,244016,687346,848974,137551,844779,1017243,236557,1006132,442134,3351,950248,113624,645454,756715,632758,996495,628309,335846,633549,239099,544000,1002648,156529,601506,416856,208768,719464,743950,440295,874155,511104,36359,245726,458655,457342,1023056,227119) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048457 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000584s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048457 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]