SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506658 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506658 [ RunTime:0.001512s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (481859,115947,357414,111543,299847,211480,153122,819257,87107,15095,520021,621599,57860,63975,877522,320005,36690,297781,407408,904097,417971,39356,456879,476098,802544,739300,464586,1025477,1036111,424762,544002,950326,83983,464580,10524,123917,644124,899829,769404,864964,302865,510936,549592,868962,296347,251207,8259,633235,672521,734974,716095,16450,426908,519247,913249,130249,475416,96252,351835,553496) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506658 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506658 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]