SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510806 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510806 [ RunTime:0.002409s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (300166,348987,272488,824818,834851,792594,349288,875779,93578,56320,1024077,725958,238560,388583,459388,12954,552850,428243,384037,129897,465405,658538,490613,335311,381866,205733,143656,21644,169385,374032,431683,70501,981651,1005761,32271,697648,455763,751602,239944,785188,450134,133710,484532,418457,237083,570492,24092,811975,35847,1034952,868192,676431,215920,621648,505485,511877,88247,340475,763009,462855) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510806 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510806 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]