SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 29289 LIMIT 1 [ RunTime:0.001396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 29289 [ RunTime:0.001068s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (982595,679454,441224,721426,1029318,114993,57969,819529,959251,757430,434900,363468,573577,161185,172424,941436,814979,564727,921166,86402,235133,402324,2718,558132,1035735,845456,115743,818422,216235,362790,879148,647540,600345,776013,561135,69964,743442,724739,1003714,780478,1028887,762178,260679,457955,776047,354093,841971,966293,676752,341799,368159,371266,756052,453234,79901,430852,98204,121774,526306,330184) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 29289 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 29289 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]