SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020504 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020504 [ RunTime:0.001777s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (234028,290188,154707,964962,450771,765670,139989,743634,621186,118265,371750,137306,423726,221438,343995,783079,956147,807486,407216,768526,1010166,59860,859102,693465,571293,566392,347273,698212,239414,203710,431282,290896,504987,450739,361376,81377,53465,335227,620485,267244,480110,670734,618177,952166,350859,783501,227806,137654,818460,971592,347016,587939,637660,395401,467485,634510,816481,653311,113512,447533) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]