SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001733s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 982098 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 982098 [ RunTime:0.001905s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (192424,896974,793064,1040638,959631,795695,336533,822850,878166,781500,8792,685670,368083,567600,847877,678022,416744,359149,477634,443332,1014784,194475,894050,89914,13591,914369,345853,1006779,703481,435362,670399,241893,779988,947248,492294,1046643,345,651998,749525,791127,56704,833272,144989,837390,190262,412009,1042340,832728,1044405,22539,984185,45500,806889,560649,282939,797038,104150,306623,243446,64888) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 982098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000559s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 982098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]