SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474414 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474414 [ RunTime:0.002208s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1042940,817409,1003817,246914,59283,744190,683535,478945,565162,315041,706056,852299,788406,673021,233890,159204,30223,1008044,706753,3178,975787,394463,128510,824649,448047,953619,78896,425308,429702,605556,191821,128342,353076,337329,673808,84699,298932,1024001,270855,1006444,538707,718561,38518,697361,308964,153531,85384,555258,493261,333281,435132,566322,797197,711731,952635,175371,687053,285974,652820,877628) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474414 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474414 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]