SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538706 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538706 [ RunTime:0.001703s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407082,1032063,811762,608287,592378,1035608,851622,654528,776968,281453,877651,810936,133131,570961,737608,68498,908046,505625,195205,323347,708560,48039,931156,488,311382,524705,767455,804286,417860,762266,392780,92121,228534,340362,626353,429677,447629,526318,505280,354401,636725,591073,650140,510743,62319,949983,63539,819617,99577,553748,787778,754745,678070,372109,596465,857650,148450,663750,927040,828295) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538706 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538706 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]