SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414210 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414210 [ RunTime:0.001605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (336202,853168,653759,619961,167771,201290,886992,533797,384178,72703,604677,456736,139233,120194,561118,497339,587252,210846,31884,297085,142615,442039,72757,430988,714712,788057,294084,1046980,629999,448756,267371,245095,802222,516935,935371,187787,351583,515820,141352,947753,510516,885749,977232,787515,863695,423753,273800,865201,146183,466083,790138,512810,658197,103215,635197,146485,12827,629840,699260,995070) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000939s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]