SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405787 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405787 [ RunTime:0.001886s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414066,494179,630808,404221,1033980,916008,525947,301528,420276,711910,685234,14960,346688,2384,996626,338015,141632,407458,497390,334192,545899,659674,346615,235096,215128,199474,811661,530012,133209,635977,737042,121395,463094,772457,324705,714888,463979,546056,767369,367486,566073,145027,170886,441054,917494,573146,428365,456929,947526,402167,858680,983120,50806,930518,958273,954612,872389,915367,911525,793032) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405787 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405787 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]