SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001771s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101924 LIMIT 1 [ RunTime:0.000606s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101924 [ RunTime:0.002842s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (369918,37815,1045616,486243,232221,641913,807544,188985,428993,1034668,707203,904783,275677,962288,587883,415265,825070,628307,642618,984693,130136,192230,577959,89360,441268,399947,126278,437915,249186,705784,862683,328106,737513,806373,994835,1042261,905431,465019,947593,1013424,581490,884552,282323,244837,120395,156957,534071,983123,971946,775851,816995,853058,522297,37558,512563,192505,1028365,39208,372700,286660) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101924 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101924 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]