SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42948 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42948 [ RunTime:0.002870s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (498557,436624,791759,957740,477757,113920,750651,697533,802327,202483,239302,1030616,141382,858482,510156,200979,275320,322688,53962,490988,875233,417296,920259,638522,483677,628616,260709,217527,255775,928843,345786,621250,144402,225182,987944,1032400,263784,67165,1042800,908590,377130,642038,158930,332540,558044,459544,569039,245116,515466,221573,339553,976224,726485,1007418,792439,36524,299234,617729,883977,361686) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42948 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42948 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]