SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484246 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484246 [ RunTime:0.001711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (361090,560124,254222,493821,212915,64019,627376,809117,511452,665064,902060,549707,969430,774570,480466,946858,727516,809131,303563,38147,221181,172816,210131,279558,210540,161597,649608,189454,941449,420842,408674,53954,855579,187648,508809,84098,260109,962679,963748,59432,23902,231925,285713,706507,621389,246053,573639,345342,449375,76532,1026452,725082,120675,387641,478801,688161,158512,110544,460110,405629) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001905s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484246 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484246 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000663s ]