SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 397826 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 397826 [ RunTime:0.001805s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (707449,839153,839292,884510,1026918,277168,554711,450593,221586,32298,403707,330525,359179,984486,779289,297882,1012713,1037640,970805,181272,168569,666043,609555,401911,784533,193266,869205,341778,486689,839620,756182,117403,237453,608331,371875,339008,772196,611136,291064,3622,411279,797720,941767,14026,138770,40967,285553,504424,218919,33184,630863,37569,536816,994443,1048859,292655,573500,100961,20257,755942) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 397826 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 397826 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]