SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 191803 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 191803 [ RunTime:0.002234s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410866,23228,976932,605935,1014055,421598,512515,19531,880749,104446,654968,480331,24101,443593,289872,420617,617740,637870,322091,737588,515498,967157,900093,930690,1040708,508643,50577,808652,54452,994723,144896,34516,381068,840470,366843,247328,589239,608172,954831,923584,713137,244973,20957,67346,128454,689236,1017801,541472,327883,240789,353928,970895,119289,560703,631944,840158,940867,1006076,693180,663631) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 191803 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 191803 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]