SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281116 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281116 [ RunTime:0.001686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (434383,1011329,919732,948568,126078,281649,41250,931610,595521,335449,118114,301231,289277,629457,132683,86499,320184,874630,530210,951092,352009,80353,415169,1008524,24103,689010,760523,398054,694699,836729,112183,947535,278666,153705,323051,362186,990412,1028835,225959,745114,376798,462546,949984,269667,828702,597217,366806,942637,429227,219625,114178,424223,261243,829274,198827,265284,417158,761047,888132,111447) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281116 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281116 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]