SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001445s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 129104 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 129104 [ RunTime:0.002233s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (332568,119244,825068,697694,106760,140187,401323,379564,932276,1036456,283027,1031127,239932,21416,558965,569233,383074,884803,272,211318,452297,500790,664611,227383,66818,645155,248786,256633,282491,625395,77293,336352,841727,720597,313604,227728,811008,16930,864403,812420,420076,679462,648054,79298,663225,357401,340351,785529,782264,407866,578013,176791,291494,597329,235034,435641,276398,190312,862646,894444) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 129104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000539s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 129104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]