SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020398 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020398 [ RunTime:0.002434s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (202813,337473,732479,98729,260062,852436,242526,683962,735972,792947,622881,784095,934130,833080,893524,311654,784790,795142,857325,131458,890222,963265,605694,71834,608153,297857,361280,73678,815420,51768,735990,765485,1002737,885476,92664,574441,244605,653154,879646,1009718,627898,605600,459501,568274,153358,638036,618664,906430,859759,906099,54850,243465,163129,461316,383688,291594,553197,422943,712997,332146) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002367s ]