SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294598 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294598 [ RunTime:0.001974s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (38078,538308,262815,673689,213118,839108,39700,718341,269065,582686,344558,1010951,58145,160265,643104,1032663,1008937,893098,734907,260161,428418,538509,698228,708633,189180,30067,492202,643468,1040549,996711,544940,206531,456447,647136,29653,450686,718399,969690,1041217,128923,238591,524848,382480,789502,1036750,644331,97008,341478,771438,282880,258022,55953,952358,59684,191298,700428,9336,731183,786024,21618) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294598 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294598 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]