SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 146450 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 146450 [ RunTime:0.001857s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413264,477282,817265,845183,970511,338919,777708,110326,1007430,1018260,763740,504042,445486,1015597,423786,852306,524001,1015533,935092,139109,738517,783709,580200,20318,511345,66942,634108,192066,11856,344891,1042841,744925,589982,999103,359699,446357,1028623,674982,493980,719592,14028,64095,617841,844848,196864,702062,576695,459581,506622,817203,425847,851904,843609,593324,262833,797331,325368,816375,208213,819227) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 146450 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 146450 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000425s ]