SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000945s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438031 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438031 [ RunTime:0.001583s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (993410,630908,544018,577728,901896,943006,869687,952146,30456,1039346,1014466,662748,809556,1013290,645202,711776,147662,278730,617910,955630,51739,12629,812310,845568,281739,901357,445920,771786,187649,907765,736294,15691,350775,968117,288449,626713,888218,485764,547246,871296,816821,586523,454017,485322,659929,107615,843687,12777,818645,826052,946773,597884,142751,239085,352980,118894,304713,37268,377886,233611) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438031 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438031 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]