SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001601s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107212 LIMIT 1 [ RunTime:0.000458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107212 [ RunTime:0.001759s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (683777,279916,277030,294356,715099,810265,743365,253940,504771,1008686,52032,216063,893432,319632,508100,156649,770009,1025107,449506,644255,63339,207225,156246,517492,523698,896012,717489,89746,206512,983267,956643,369698,153811,851506,168045,400630,82773,448623,851271,626707,555002,906431,511281,789653,537620,900492,707224,956711,523321,472257,118354,319494,489952,57850,696679,523626,503714,980928,158121,568277) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000515s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000743s ]