SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001344s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311613 LIMIT 1 [ RunTime:0.001214s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311613 [ RunTime:0.002186s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (852306,846443,822381,225978,331025,910097,223040,532331,674369,1019071,834450,278125,698614,119979,854646,3523,347154,869958,36218,547825,787393,330512,108277,1033144,854732,571230,898936,396411,939022,529662,670148,516663,266686,405411,536714,900203,189282,47709,2008,165430,425633,883316,229553,54040,838829,132038,807626,94412,638063,905372,884846,1033774,832328,578768,216063,604832,955958,118060,957968,666067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001747s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]