SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001510s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 356629 LIMIT 1 [ RunTime:0.000527s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 356629 [ RunTime:0.003516s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010236,387333,614351,824551,589685,1027568,442685,152933,449872,476756,166686,692963,64210,185256,924848,460293,103649,795914,237342,645705,968513,145963,308658,651669,148888,579394,84721,925685,524361,701984,918005,237946,213722,840800,311631,677384,381052,511469,34550,493642,378188,862843,893059,1037881,1012895,541521,586556,983897,456053,347792,413222,999325,114359,671550,780464,319464,661683,1013170,774949,47574) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 356629 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 356629 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000678s ]