SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537941 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537941 [ RunTime:0.002740s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (151333,447132,149761,288195,96006,139501,187443,563521,425900,481260,696845,54670,717150,528874,469571,780816,26144,546012,607777,339662,492879,735498,157702,439708,243177,584430,614572,237373,914022,361443,94062,651878,684345,569820,38750,125270,282218,809625,267175,295734,934682,800768,692671,239590,797290,1011402,824224,232452,793163,66995,294799,383080,429243,100632,293947,672066,736519,472804,900619,308967) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000382s ]