SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001523s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043101 LIMIT 1 [ RunTime:0.000537s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043101 [ RunTime:0.002733s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019537,157198,937724,296814,472578,891297,381431,156495,259654,67472,889703,927682,1038913,840179,177295,674154,422067,715265,193472,696714,616356,969020,538054,391854,33291,753967,183837,332559,565326,971964,291510,570847,1000603,719566,271891,837641,552830,728250,27767,587638,580201,772021,41088,232409,907152,355820,291906,626639,981848,523322,299443,308232,775810,512679,582704,607995,654882,178764,162118) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]