SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001440s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5989 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5989 [ RunTime:0.002146s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (608241,100246,541877,126321,342,90655,660177,1015660,530162,127159,26119,880613,30720,998616,739591,879822,623159,134305,672939,574651,904995,648705,44509,691059,800840,546576,175545,129991,449506,717253,475478,792485,32209,734613,892521,622180,954439,743431,601298,3956,818439,701377,695686,301448,328574,29690,925021,200529,829821,958924,660955,829171,902744,314248,880829,275886,376893,104695,172272,995314) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5989 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5989 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]