SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016933 LIMIT 1 [ RunTime:0.001032s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016933 [ RunTime:0.002422s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (290910,662035,326312,487366,431242,863575,772106,423602,701824,412373,791133,264054,251560,2307,787426,540825,432719,1028519,357552,284097,206660,264517,352132,703177,816044,363027,710774,585247,808371,977058,499529,99355,955258,928265,20365,19164,424220,247650,799451,493124,976833,117439,510310,340238,447940,1025134,730048,338037,952571,425194,392052,256760,506408,891646,855959,191117,706858,754630,41181,654926) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016933 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016933 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]