SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001477s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046696 LIMIT 1 [ RunTime:0.001380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046696 [ RunTime:0.004239s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (404050,639558,500206,386829,693130,629784,438316,664702,272477,985999,795372,218065,350083,515459,229758,71664,966426,433091,765979,513260,204376,602135,547462,654649,605198,491211,990010,627255,874669,816804,100177,770144,337026,124489,982907,628491,974792,21093,690528,641258,486674,479104,746252,420065,367921,673289,975750,227956,1006988,1008524,136002,135812,169690,160730,842794,567704,867332,142750,756673,281811) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004623s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046696 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046696 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]