SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 394513 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 394513 [ RunTime:0.003713s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (82542,629422,311276,77207,440624,815771,841184,190063,521084,497929,40434,716231,658398,443360,666933,687435,644837,1558,682506,66090,759016,831094,913150,756792,847346,334847,412213,885347,980022,134961,381447,297418,540924,395405,262334,380974,685427,1020571,666050,115591,965022,979491,18662,24345,943752,19635,589791,555259,460135,258084,64517,286346,644709,773560,764829,694781,261365,258970,979671,800240) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 394513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 394513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001472s ]