SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409876 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409876 [ RunTime:0.001500s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (843669,54789,561872,49013,95315,761488,980646,576177,95757,871285,519014,212589,1045594,1026301,889914,608633,691161,748964,244637,764875,115642,447813,694051,622320,704166,681432,407341,786522,162196,842981,458051,214088,704735,509674,32307,1039300,373704,659253,300448,792882,429121,378927,928931,600593,480496,564296,643163,795799,992310,461029,203534,25040,669369,381782,566439,735687,309317,876322,1044613,1012417) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409876 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409876 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]