SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 589518 LIMIT 1 [ RunTime:0.000296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 589518 [ RunTime:0.002101s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (254040,639507,105239,538196,968251,390940,677401,139302,839583,895654,295854,486894,49681,287144,781793,725254,360474,546683,559940,547355,854458,949539,267901,426905,33684,578862,873326,731198,800213,508024,33637,724673,200608,8061,825506,643263,208071,354172,374932,9768,1041845,593090,763151,81298,332622,874851,105905,928097,182558,596150,270813,543746,3986,651673,384775,810409,15618,520470,593553,799031) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 589518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 589518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]