SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803504 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803504 [ RunTime:0.001664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (779935,313091,1013593,756298,219132,524437,1010160,181061,1011529,578253,943957,719465,651048,53445,229652,267323,133252,503023,612367,273191,563713,734906,168100,826368,683035,467855,11629,48705,387349,106009,538512,951827,209150,559111,983401,46393,19927,554649,466680,768115,601982,431286,365234,259282,999532,753303,847236,379839,265333,48805,302400,242086,927487,368227,592389,506764,920661,1013684,398262,363865) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000625s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]