SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473139 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473139 [ RunTime:0.001617s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028995,787928,738330,364874,503497,443643,1027970,532728,182606,74363,536219,964945,1031848,1012379,784614,959254,953761,210508,205650,345235,480804,750956,519426,869333,397394,946139,10224,740466,663313,394615,597717,507520,71360,16788,63326,36942,241590,850239,1000099,338162,972422,613377,1023932,938463,542656,23750,915063,886634,415278,301381,702318,651748,885122,140882,363496,814676,256805,431672,669997,878610) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473139 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473139 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]