SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311680 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311680 [ RunTime:0.001675s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (341407,724694,154754,137080,522596,453564,777007,73213,942229,398344,670222,446030,305615,819429,375847,769640,500620,763753,75579,22122,457452,74965,203784,119447,333956,881271,387146,377715,773171,862296,754423,49692,147223,879359,969487,901621,580911,513026,441488,139480,313879,736580,834215,880659,395498,653852,159141,358616,612842,115860,454665,358901,218163,216512,548169,258291,444285,62349,196055,464076) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]